[dbo].[BAECartOrderGetAllForUser]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECartOrderGetAllForUser

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@Id	varchar(32)	32

SQL Script

create procedure [dbo].[BAECartOrderGetAllForUser] @Id varchar(32) as
SELECT *
    FROM CartOrder co
    INNER JOIN CartItem ci on ci.CartItemID = co.CartItemID
    WHERE ci.UserID = @Id ORDER BY co.Title

GO

Uses

[dbo].[CartItem]
[dbo].[CartOrder]
dbo